Hệ thống quản lý trường học bằng PHP / MySQLi
1 <?php
2 error_reporting(0);
3 $conn = mysqli_connect("localhost","root","");
4 mysqli_select_db("sms2",$conn);
5
6 if(isset($_POST["submit"]) && $_POST["submit"]!="") {
7 $usersCount = count($_POST["firstname"]);
8 for($i=0;$i<$usersCount;$i++) {
9 mysqli_query("UPDATE studentstable set course_id='" . $_POST["course_id"][$i] . "' WHERE student_id='" . $_POST["student_id"][$i] . "'");
10 }
11 header("Location:pro1.php");
12 }
13 ?>
14 <?php
15 SESSION_START();
16 ?>
17 <?php
18 include("connect.php");
19 ?>
20 <!DOCTYPE html>
21 <html>
22
23 <head>
24 <meta charset="utf-8">
25 <meta name="viewport" content="width=device-width, initial-scale=1.0">
26 <title>school management system</title>
27 <link rel="shortcut icon" href="assets/img/title.gif" type="image/x-icon">
28 <link rel="stylesheet" href="assets/css/bootstrap.min.css">
29 <link href="assets/css/loader.css" rel="stylesheet" />
30 <script src="assets/js/canvasjs.min.js"></script>
31 <!--*****jquery -3.2.1.js file supports the use of dropdown***-->
32 <script src="assets/js/jquery-3.2.1.js"></script>
33 <!--this two links are for styling up the table populated with data-->
34 <link rel="stylesheet" type="text/css" href="styles.css" />
35 <script language="javascript" src="users.js" type="text/javascript"></script>
36 </head>
37
38 <body >
39 <!--end of heading section-->
40 <ul class="nav navbar-right top-nav">
41 <div class="dropdown">
42 <button class="btn btn-primary dropdown-toggle" type="button" data-toggle="dropdown" >
43 <?php
44 //Check to see if the user is logged in.if not redirect user to the loging page.
45
46 if(isset($_SESSION['fname']))
47 {
48 echo "Current user: ".$_SESSION['fname']. " ".$_SESSION['lname']. " ";
49 }else{
50 echo "<script type='text/javascript'>
51 alert( 'You must Log in to use the system');
52 </script>";
53 echo "<script>
54 window.location = 'index.php'
55 </script>";
56 }
57 ?>
58 <span class="caret"></span></button>
59 <ul class="dropdown-menu">
60 <li><a href="manage_account.php"><i class="fa fa-users fa-lg"></i> View User</a></li>
61 <li><a href="register_form.php"><i class="fa fa-users fa-lg"></i> Add New User</a></li>
62 <li class="divider"></li>
63 <li><a href="session_logout.php"><i class="fa fa-fw fa-power-off"></i> Log Out</a></li>
64 </ul>
65 </div>
66 </ul>
67 <!--************************************************-->
68 <div style="
69 font-family:Nyala, Arial;
70 text-align: left;
71 background-color: #526F35;
72 padding: 20px;
73 color:white;
74 width: 100%;
75 height: 150px;">
76 <!--This codes to load the image loader-->
77 <div id="loading">
78 <img id="loading-image" src="assets/img/loader.gif" alt="Loading..." />
79 </div>
80 <!--this is the heading section-->
81 <h2>
82 <?php
83 $sql="SELECT * FROM companyinfo";
84 $result=mysqli_query($db,$sql) or die("error getting data");
85 $num_rows=mysqli_num_rows($result);
86 while($row=mysqli_fetch_array($result))
87 {
88 echo '<image style="height:82px; width:82px;" src="data:image;base64,'. $row['clogo'].' "> ';
89 $cname = $row['cname'];
90 $cemail = $row['cemail'];
91 $ccontact = $row['ccontact'];
92 $clocation = $row['clocation'];
93 }?>
94 <?php
95 echo $cname;
96 ?>
97
98 <div style="float:right; font-size:20px;text-align:right;">
99
100 <img src="assets/img/mail2.png">Email: <?php echo $cemail; ?><br>
101 <img src="assets/img/call1.png">Contact:<?php echo $ccontact; ?><br>
102 <img src="assets/img/location.png">Location: <?php echo $clocation; ?>
103
104 </div>
105 </h2>
106 </div>
107 <!--end of heading section-->
108 <div>
109 <ul class="nav nav-tabs">
110 <li ><a href="homepage.php" >Administration <img src="assets/img/details.png"></a></li>
111 <li ><a href="students.php" >Students <img src="assets/img/student48.png"></a></li>
112 <li><a href="staff.php">Staff Member <img src="assets/img/staff48.png"></a></li>
113 <li><a href="course.php" >Courses <img src="assets/img/course.png"></a></li>
114 <li><a href="departments.php" >Departments <img src="assets/img/department.png"></a></li>
115 <li><a href="markstep1.php" >Exams <img src="assets/img/update.png"></a></li>
116 <li><a href="hostel.php" >Hostel <img src="assets/img/details.png"></a></li>
117 <li><a href="sms.php">SMS <img src="assets/img/details.png"></a></li>
118 <!--<li><a href="tab-8" role="tab" data-toggle="tab">Hostel <img src="assets/img/details.png"></a></li>
119 <li><a href="tab-7" role="tab" data-toggle="tab">Parents <img src="assets/img/details.png"></a></li>-->
120
121 </ul>
122 <div class="tab-content">
123 <div class="tab-pane active" role="tabpanel" id="tab-1">
124
125 <p>
126 <div class="table-responsive" >
127 <!--****************************************************************************-->
128 <div class="container" style="width:100%">
129
130 <ul class="nav nav-tabs">
131 <li ><a href="pro1.php">Choose Class <img src="assets/img/new.png"> </a></li>
132 <li ><a href="pro2.php">Check List<img src="assets/img/view2.png"></a></li>
133 <li class="active"><a href="pro3.php">Edit Student<img src="assets/img/view2.png"></a></li>
134
135 </ul>
136 <br>
137
138 </div>
139
140 <!--*************************************************************************************************************************-->
141
142 <div id="page-wrapper">
143 <div class="container-fluid">
144
145
146 <!-- Page Heading -->
147 <nav>
148 <form name="frmUser" method="post" action="">
149 <div style="width:100%;">
150 <div class="table-responsive">
151 <table cellpadding="0" cellspacing="0" border="0" class="table" id="myTable">
152 <tr class="tableheader">
153 <td>Edit Students. <?php echo count($_POST["users"]); ?> record(s) selected</td>
154 </tr>
155 <?php
156 $rowCount = count($_POST["users"]);
157 for($i=0;$i<$rowCount;$i++) {
158 $result = mysqli_query("SELECT * FROM studentstable WHERE student_id='" . $_POST["users"][$i] . "'");
159 $row[$i]= mysqli_fetch_array($result);
160 ?>
161 <tr>
162 <td>
163 <table border="0" cellpadding="10" cellspacing="0" width="500" align="center" class="tblSaveForm">
164 <tr>
165 <td><label>Student Name</label></td>
166 <td><input type="hidden" name="student_id[]" class="txtField" value="<?php echo $row[$i]['student_id']; ?>">
167 <input type="text" name="firstname[]" class="txtField" value="<?php echo $row[$i]['firstname']." ".$row[$i]['lastname']." S# ".$row[$i]['student_id'];; ?>"></td>
168 </tr>
169 <tr>
170 <?php
171 //checking the current class inorder to promote to the next class
172 $class=$row[$i]['course_id'];
173 if ($class==1){
174 $promoteto=2;
175 }elseif ($class==2) {
176 $promoteto=3;
177 }elseif ($class==3) {
178 $promoteto=4;
179 }
180 elseif ($class==4) {
181 $promoteto=5;
182
183 }elseif ($class==5) {
184 $promoteto=6;
185 if ($promoteto==6){
186 $msg="Your action cannot be completed, unless the student(s) has repeated. You may choose to edit the value in text box to your desired class";
187 }
188 }
189 //5 stand for alumni
190 ?>
191 <div style="width:100%; background-color:red;">
192 <?php
193 echo $msg;
194
195 ?>
196 </div>
197
198
199 <td><label>Course ID</label></td>
200 <td><input type="text" name="course_id[]" class="txtField" value="<?php echo $promoteto; ?>"></td>
201 </tr>
202 </table>
203 </td>
204 </tr>
205 <?php
206 }
207 ?>
208 <tr>
209 <td colspan="2"><input type="submit" name="submit" value="Submit" class="btnSubmit"></td>
210 </tr>
211 </table>
212 </div>
213 </form>
214
215
216 </div>
217 </div>
218 </div>
219 </div>
220
221
222 <div class="col-md-12" style="background-color:#526F35;bottom:0px; position:fixed;">
223 <p class="text-center text-danger" style="color:white;" >@J. Muthama Tel: +254729734768</p>
224 </div>
225 <script src="assets/js/jquery.min.js"></script>
226 <script src="assets/bootstrap/js/bootstrap.min.js"></script>
227 <script src="assets/js/affix.js"></script>
228 <script src="assets/js/alert.js"></script>
229 <script src="assets/js/alert1.js"></script>
230 <script src="assets/js/bootstrap.js"></script>
231 <script src="assets/js/bootstrap.min.js"></script>
232 <script src="assets/js/bootstrap-datepicker.js"></script>
233 <script src="assets/js/bootstrap-wysihtml5.js"></script>
234 <script src="assets/js/button.js"></script>
235 <script src="assets/js/carousel.js"></script>
236 <script src="assets/js/chosen.jquery.min.js"></script>
237 <script src="assets/js/ckeditor.js"></script>
238 <script src="assets/js/collapse.js"></script>
239 <script src="assets/js/color.js"></script>
240 <script src="assets/js/dropdown.js"></script>
241 <script src="assets/js/DT_bootstrap.js"></script>
242 <script src="assets/js/dynamic.js"></script>
243 <script src="assets/js/ie-emulation-modes-warning.js"></script>
244 <script src="assets/js/jquery.dataTables.js"></script>
245 <script src="assets/js/jquery.dataTables.min.js"></script>
246 <script src="assets/js/jquery.dialog.js"></script>
247 <script src="assets/js/jquery.hoverdir.js"></script>
248 <script src="assets/js/jquery.jgrowl.js"></script>
249 <script src="assets/js/jquery.knob.js"></script>
250 <script src="assets/js/jquery.uniform.min.js"></script>
251 <script src="assets/js/jquery-1.8.3.min.js"></script>
252 <script src="assets/js/jquery-1.9.1.js"></script>
253 <script src="assets/js/jquery-1.9.1.min.js"></script>
254 <script src="assets/js/jquery-1.10.2.js"></script>
255 <script src="assets/js/jquery-1.11.0.js"></script>
256 <script src="assets/js/jquery-ui-1.9.2.custom.min.js"></script>
257 <script src="assets/js/jquery-ui-1.10.3.js"></script>
258 <script src="assets/js/modal.js"></script>
259 <script src="assets/js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
260 <script src="assets/js/myjquery.js"></script>
261 <script src="assets/js/myjquery1.js"></script>
262 <script src="assets/js/npm.js"></script>
263 <script src="assets/js/popover.js"></script>
264 <script src="assets/js/profile.js"></script>
265 <script src="assets/js/raphael-min.js"></script>
266 <script src="assets/js/sb-admin-2.js"></script>
267 <script src="assets/js/scripts.js"></script>
268 <script src="assets/js/scrollspy.js"></script>
269 <script src="assets/js/tab.js"></script>
270 <script src="assets/js/tooltip.js"></script>
271 <script src="assets/js/transition.js"></script>
272 <script src="assets/js/wysihtml5-0.3.0.js"></script>
273 <script language="javascript" type="text/javascript">
274 $(window).load(function()
275 {
276 $('#loading').hide();
277 });
278 </script>
279 </body>
280
281 </html>